package com.accenture.fd.dao;

import java.util.List;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Result;
import org.apache.ibatis.annotations.Results;
import org.apache.ibatis.annotations.Select;

import com.accenture.fd.entity.MappingEntity;

@Mapper
public interface MappingTblDao {

	     @Select("select\r\n" + 
	     		"  Section,\r\n" + 
	     		"  Design_type_ID,\r\n" + 
	     		"  Screen_ID,\r\n" + 
	     		"  Temporary_screen_ID,\r\n" + 
	     		"  Screen_name,\r\n" + 
	     		"  Screen_item_name,\r\n" + 
	     		"  Attribute_CD,\r\n" + 
	     		"  Sorting,\r\n" + 
	     		"  Entity_name,\r\n" + 
	     		"  Logical_data_item_name\r\n" + 
	     		"form\r\n" + 
	     		"  TB00006")
	     @Results({
	    	 @Result(column = "Section", property = "section"),
	    	 @Result(column = "Design_type_ID", property = "designTypeId"),
	    	 @Result(column = "Screen_ID", property = "screenId"),
	    	 @Result(column = "Temporary_screen_ID", property = "temporaryScreenId"),
	    	 @Result(column = "Screen_name", property = "screenName"),
	    	 @Result(column = "Screen_item_name", property = "screenItemName"),
	    	 @Result(column = "Attribute_CD", property = "attributeCd"),
	    	 @Result(column = "Sorting", property = "sorting"),
	    	 @Result(column = "Entity_name", property = "entityName"),
	    	 @Result(column = "Logical_data_item_name", property = "logicalDataItemName"),
	     })
	     List<MappingEntity> getMappingList();
	     
	     @Select("select \r\n" + 
		     		"  Logical_data_item_name\r\n" + 
		     		"from TB00006")
		     @Results({
		    	 @Result(property = "logicalDataItemName", column = "Logical_data_item_name"),
		     })
		     List<String> getLogicalDataItemName();
}